Usually the information in a database table is logically divided into records. These records typically contain one or more components called fields. In DAL, record fields will be associated together via a common DAL variable prefix name. Ability to access individual data elements is supported by using a dot (".") operator.
Here is an example:
Assume a table contains records with three fields:
In the script you will designate a prefix name for these variables when using the database functions. So you could end up with something like:
RECORD.LOANTYPE
RECORD.PAYMENT
RECORD.DUEDATE
Each field from the same record will have the same prefix name (which you can assign) concatenated with the dot operator.
© Copyright 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices